IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GenerateDataDictionary]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GenerateDataDictionary];

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[GenerateDataDictionaryExclusionList]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GenerateDataDictionaryExclusionList];

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[GenerateDataDictionaryAddExclusion]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GenerateDataDictionaryAddExclusion];

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DataDictionaryExclusions]') AND type in (N'U'))
DROP TABLE [dbo].[DataDictionaryExclusions]